CREATE INDEX idx_reseller
  ON [JohnnySins].[dbo].[EpochTransStats](ets_reseller_code)
GO
CREATE INDEX idx_product
  ON [JohnnySins].[dbo].[EpochTransStats](ets_pi_code)
GO
CREATE INDEX idx_transdate
  ON [JohnnySins].[dbo].[EpochTransStats](ets_transaction_date)
GO
CREATE INDEX idx_type
  ON [JohnnySins].[dbo].[EpochTransStats](ets_transaction_type)
GO